package cn.sh.yhk.oracle;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class TTeamSegExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TTeamSegExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andSegIdIsNull() {
            addCriterion("SEG_ID is null");
            return (Criteria) this;
        }

        public Criteria andSegIdIsNotNull() {
            addCriterion("SEG_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSegIdEqualTo(BigDecimal value) {
            addCriterion("SEG_ID =", value, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdNotEqualTo(BigDecimal value) {
            addCriterion("SEG_ID <>", value, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdGreaterThan(BigDecimal value) {
            addCriterion("SEG_ID >", value, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SEG_ID >=", value, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdLessThan(BigDecimal value) {
            addCriterion("SEG_ID <", value, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SEG_ID <=", value, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdIn(List<BigDecimal> values) {
            addCriterion("SEG_ID in", values, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdNotIn(List<BigDecimal> values) {
            addCriterion("SEG_ID not in", values, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SEG_ID between", value1, value2, "segId");
            return (Criteria) this;
        }

        public Criteria andSegIdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SEG_ID not between", value1, value2, "segId");
            return (Criteria) this;
        }

        public Criteria andTeamIdIsNull() {
            addCriterion("TEAM_ID is null");
            return (Criteria) this;
        }

        public Criteria andTeamIdIsNotNull() {
            addCriterion("TEAM_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTeamIdEqualTo(BigDecimal value) {
            addCriterion("TEAM_ID =", value, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdNotEqualTo(BigDecimal value) {
            addCriterion("TEAM_ID <>", value, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdGreaterThan(BigDecimal value) {
            addCriterion("TEAM_ID >", value, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TEAM_ID >=", value, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdLessThan(BigDecimal value) {
            addCriterion("TEAM_ID <", value, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TEAM_ID <=", value, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdIn(List<BigDecimal> values) {
            addCriterion("TEAM_ID in", values, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdNotIn(List<BigDecimal> values) {
            addCriterion("TEAM_ID not in", values, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TEAM_ID between", value1, value2, "teamId");
            return (Criteria) this;
        }

        public Criteria andTeamIdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TEAM_ID not between", value1, value2, "teamId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdIsNull() {
            addCriterion("SEGGROUP_ID is null");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdIsNotNull() {
            addCriterion("SEGGROUP_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdEqualTo(BigDecimal value) {
            addCriterion("SEGGROUP_ID =", value, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdNotEqualTo(BigDecimal value) {
            addCriterion("SEGGROUP_ID <>", value, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdGreaterThan(BigDecimal value) {
            addCriterion("SEGGROUP_ID >", value, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SEGGROUP_ID >=", value, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdLessThan(BigDecimal value) {
            addCriterion("SEGGROUP_ID <", value, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SEGGROUP_ID <=", value, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdIn(List<BigDecimal> values) {
            addCriterion("SEGGROUP_ID in", values, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdNotIn(List<BigDecimal> values) {
            addCriterion("SEGGROUP_ID not in", values, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SEGGROUP_ID between", value1, value2, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andSeggroupIdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SEGGROUP_ID not between", value1, value2, "seggroupId");
            return (Criteria) this;
        }

        public Criteria andCreateDtmIsNull() {
            addCriterion("CREATE_DTM is null");
            return (Criteria) this;
        }

        public Criteria andCreateDtmIsNotNull() {
            addCriterion("CREATE_DTM is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDtmEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_DTM =", value, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmNotEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_DTM <>", value, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmGreaterThan(Date value) {
            addCriterionForJDBCDate("CREATE_DTM >", value, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_DTM >=", value, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmLessThan(Date value) {
            addCriterionForJDBCDate("CREATE_DTM <", value, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_DTM <=", value, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmIn(List<Date> values) {
            addCriterionForJDBCDate("CREATE_DTM in", values, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmNotIn(List<Date> values) {
            addCriterionForJDBCDate("CREATE_DTM not in", values, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATE_DTM between", value1, value2, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateDtmNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATE_DTM not between", value1, value2, "createDtm");
            return (Criteria) this;
        }

        public Criteria andCreateIdIsNull() {
            addCriterion("CREATE_ID is null");
            return (Criteria) this;
        }

        public Criteria andCreateIdIsNotNull() {
            addCriterion("CREATE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCreateIdEqualTo(BigDecimal value) {
            addCriterion("CREATE_ID =", value, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdNotEqualTo(BigDecimal value) {
            addCriterion("CREATE_ID <>", value, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdGreaterThan(BigDecimal value) {
            addCriterion("CREATE_ID >", value, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CREATE_ID >=", value, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdLessThan(BigDecimal value) {
            addCriterion("CREATE_ID <", value, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CREATE_ID <=", value, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdIn(List<BigDecimal> values) {
            addCriterion("CREATE_ID in", values, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdNotIn(List<BigDecimal> values) {
            addCriterion("CREATE_ID not in", values, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CREATE_ID between", value1, value2, "createId");
            return (Criteria) this;
        }

        public Criteria andCreateIdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CREATE_ID not between", value1, value2, "createId");
            return (Criteria) this;
        }

        public Criteria andSegSqIsNull() {
            addCriterion("SEG_SQ is null");
            return (Criteria) this;
        }

        public Criteria andSegSqIsNotNull() {
            addCriterion("SEG_SQ is not null");
            return (Criteria) this;
        }

        public Criteria andSegSqEqualTo(Short value) {
            addCriterion("SEG_SQ =", value, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqNotEqualTo(Short value) {
            addCriterion("SEG_SQ <>", value, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqGreaterThan(Short value) {
            addCriterion("SEG_SQ >", value, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqGreaterThanOrEqualTo(Short value) {
            addCriterion("SEG_SQ >=", value, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqLessThan(Short value) {
            addCriterion("SEG_SQ <", value, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqLessThanOrEqualTo(Short value) {
            addCriterion("SEG_SQ <=", value, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqIn(List<Short> values) {
            addCriterion("SEG_SQ in", values, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqNotIn(List<Short> values) {
            addCriterion("SEG_SQ not in", values, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqBetween(Short value1, Short value2) {
            addCriterion("SEG_SQ between", value1, value2, "segSq");
            return (Criteria) this;
        }

        public Criteria andSegSqNotBetween(Short value1, Short value2) {
            addCriterion("SEG_SQ not between", value1, value2, "segSq");
            return (Criteria) this;
        }

        public Criteria andDepCdIsNull() {
            addCriterion("DEP_CD is null");
            return (Criteria) this;
        }

        public Criteria andDepCdIsNotNull() {
            addCriterion("DEP_CD is not null");
            return (Criteria) this;
        }

        public Criteria andDepCdEqualTo(String value) {
            addCriterion("DEP_CD =", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdNotEqualTo(String value) {
            addCriterion("DEP_CD <>", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdGreaterThan(String value) {
            addCriterion("DEP_CD >", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdGreaterThanOrEqualTo(String value) {
            addCriterion("DEP_CD >=", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdLessThan(String value) {
            addCriterion("DEP_CD <", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdLessThanOrEqualTo(String value) {
            addCriterion("DEP_CD <=", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdLike(String value) {
            addCriterion("DEP_CD like", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdNotLike(String value) {
            addCriterion("DEP_CD not like", value, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdIn(List<String> values) {
            addCriterion("DEP_CD in", values, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdNotIn(List<String> values) {
            addCriterion("DEP_CD not in", values, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdBetween(String value1, String value2) {
            addCriterion("DEP_CD between", value1, value2, "depCd");
            return (Criteria) this;
        }

        public Criteria andDepCdNotBetween(String value1, String value2) {
            addCriterion("DEP_CD not between", value1, value2, "depCd");
            return (Criteria) this;
        }

        public Criteria andArrCdIsNull() {
            addCriterion("ARR_CD is null");
            return (Criteria) this;
        }

        public Criteria andArrCdIsNotNull() {
            addCriterion("ARR_CD is not null");
            return (Criteria) this;
        }

        public Criteria andArrCdEqualTo(String value) {
            addCriterion("ARR_CD =", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdNotEqualTo(String value) {
            addCriterion("ARR_CD <>", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdGreaterThan(String value) {
            addCriterion("ARR_CD >", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdGreaterThanOrEqualTo(String value) {
            addCriterion("ARR_CD >=", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdLessThan(String value) {
            addCriterion("ARR_CD <", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdLessThanOrEqualTo(String value) {
            addCriterion("ARR_CD <=", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdLike(String value) {
            addCriterion("ARR_CD like", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdNotLike(String value) {
            addCriterion("ARR_CD not like", value, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdIn(List<String> values) {
            addCriterion("ARR_CD in", values, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdNotIn(List<String> values) {
            addCriterion("ARR_CD not in", values, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdBetween(String value1, String value2) {
            addCriterion("ARR_CD between", value1, value2, "arrCd");
            return (Criteria) this;
        }

        public Criteria andArrCdNotBetween(String value1, String value2) {
            addCriterion("ARR_CD not between", value1, value2, "arrCd");
            return (Criteria) this;
        }

        public Criteria andDepDtIsNull() {
            addCriterion("DEP_DT is null");
            return (Criteria) this;
        }

        public Criteria andDepDtIsNotNull() {
            addCriterion("DEP_DT is not null");
            return (Criteria) this;
        }

        public Criteria andDepDtEqualTo(Date value) {
            addCriterionForJDBCDate("DEP_DT =", value, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtNotEqualTo(Date value) {
            addCriterionForJDBCDate("DEP_DT <>", value, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtGreaterThan(Date value) {
            addCriterionForJDBCDate("DEP_DT >", value, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("DEP_DT >=", value, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtLessThan(Date value) {
            addCriterionForJDBCDate("DEP_DT <", value, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("DEP_DT <=", value, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtIn(List<Date> values) {
            addCriterionForJDBCDate("DEP_DT in", values, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtNotIn(List<Date> values) {
            addCriterionForJDBCDate("DEP_DT not in", values, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("DEP_DT between", value1, value2, "depDt");
            return (Criteria) this;
        }

        public Criteria andDepDtNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("DEP_DT not between", value1, value2, "depDt");
            return (Criteria) this;
        }

        public Criteria andArrDtIsNull() {
            addCriterion("ARR_DT is null");
            return (Criteria) this;
        }

        public Criteria andArrDtIsNotNull() {
            addCriterion("ARR_DT is not null");
            return (Criteria) this;
        }

        public Criteria andArrDtEqualTo(Date value) {
            addCriterionForJDBCDate("ARR_DT =", value, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtNotEqualTo(Date value) {
            addCriterionForJDBCDate("ARR_DT <>", value, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtGreaterThan(Date value) {
            addCriterionForJDBCDate("ARR_DT >", value, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("ARR_DT >=", value, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtLessThan(Date value) {
            addCriterionForJDBCDate("ARR_DT <", value, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("ARR_DT <=", value, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtIn(List<Date> values) {
            addCriterionForJDBCDate("ARR_DT in", values, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtNotIn(List<Date> values) {
            addCriterionForJDBCDate("ARR_DT not in", values, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("ARR_DT between", value1, value2, "arrDt");
            return (Criteria) this;
        }

        public Criteria andArrDtNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("ARR_DT not between", value1, value2, "arrDt");
            return (Criteria) this;
        }

        public Criteria andPlanetpIsNull() {
            addCriterion("PLANETP is null");
            return (Criteria) this;
        }

        public Criteria andPlanetpIsNotNull() {
            addCriterion("PLANETP is not null");
            return (Criteria) this;
        }

        public Criteria andPlanetpEqualTo(String value) {
            addCriterion("PLANETP =", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpNotEqualTo(String value) {
            addCriterion("PLANETP <>", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpGreaterThan(String value) {
            addCriterion("PLANETP >", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpGreaterThanOrEqualTo(String value) {
            addCriterion("PLANETP >=", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpLessThan(String value) {
            addCriterion("PLANETP <", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpLessThanOrEqualTo(String value) {
            addCriterion("PLANETP <=", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpLike(String value) {
            addCriterion("PLANETP like", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpNotLike(String value) {
            addCriterion("PLANETP not like", value, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpIn(List<String> values) {
            addCriterion("PLANETP in", values, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpNotIn(List<String> values) {
            addCriterion("PLANETP not in", values, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpBetween(String value1, String value2) {
            addCriterion("PLANETP between", value1, value2, "planetp");
            return (Criteria) this;
        }

        public Criteria andPlanetpNotBetween(String value1, String value2) {
            addCriterion("PLANETP not between", value1, value2, "planetp");
            return (Criteria) this;
        }

        public Criteria andStopIsNull() {
            addCriterion("STOP is null");
            return (Criteria) this;
        }

        public Criteria andStopIsNotNull() {
            addCriterion("STOP is not null");
            return (Criteria) this;
        }

        public Criteria andStopEqualTo(Short value) {
            addCriterion("STOP =", value, "stop");
            return (Criteria) this;
        }

        public Criteria andStopNotEqualTo(Short value) {
            addCriterion("STOP <>", value, "stop");
            return (Criteria) this;
        }

        public Criteria andStopGreaterThan(Short value) {
            addCriterion("STOP >", value, "stop");
            return (Criteria) this;
        }

        public Criteria andStopGreaterThanOrEqualTo(Short value) {
            addCriterion("STOP >=", value, "stop");
            return (Criteria) this;
        }

        public Criteria andStopLessThan(Short value) {
            addCriterion("STOP <", value, "stop");
            return (Criteria) this;
        }

        public Criteria andStopLessThanOrEqualTo(Short value) {
            addCriterion("STOP <=", value, "stop");
            return (Criteria) this;
        }

        public Criteria andStopIn(List<Short> values) {
            addCriterion("STOP in", values, "stop");
            return (Criteria) this;
        }

        public Criteria andStopNotIn(List<Short> values) {
            addCriterion("STOP not in", values, "stop");
            return (Criteria) this;
        }

        public Criteria andStopBetween(Short value1, Short value2) {
            addCriterion("STOP between", value1, value2, "stop");
            return (Criteria) this;
        }

        public Criteria andStopNotBetween(Short value1, Short value2) {
            addCriterion("STOP not between", value1, value2, "stop");
            return (Criteria) this;
        }

        public Criteria andSegTpIsNull() {
            addCriterion("SEG_TP is null");
            return (Criteria) this;
        }

        public Criteria andSegTpIsNotNull() {
            addCriterion("SEG_TP is not null");
            return (Criteria) this;
        }

        public Criteria andSegTpEqualTo(Short value) {
            addCriterion("SEG_TP =", value, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpNotEqualTo(Short value) {
            addCriterion("SEG_TP <>", value, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpGreaterThan(Short value) {
            addCriterion("SEG_TP >", value, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpGreaterThanOrEqualTo(Short value) {
            addCriterion("SEG_TP >=", value, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpLessThan(Short value) {
            addCriterion("SEG_TP <", value, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpLessThanOrEqualTo(Short value) {
            addCriterion("SEG_TP <=", value, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpIn(List<Short> values) {
            addCriterion("SEG_TP in", values, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpNotIn(List<Short> values) {
            addCriterion("SEG_TP not in", values, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpBetween(Short value1, Short value2) {
            addCriterion("SEG_TP between", value1, value2, "segTp");
            return (Criteria) this;
        }

        public Criteria andSegTpNotBetween(Short value1, Short value2) {
            addCriterion("SEG_TP not between", value1, value2, "segTp");
            return (Criteria) this;
        }

        public Criteria andFaresourceidIsNull() {
            addCriterion("FARESOURCEID is null");
            return (Criteria) this;
        }

        public Criteria andFaresourceidIsNotNull() {
            addCriterion("FARESOURCEID is not null");
            return (Criteria) this;
        }

        public Criteria andFaresourceidEqualTo(String value) {
            addCriterion("FARESOURCEID =", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidNotEqualTo(String value) {
            addCriterion("FARESOURCEID <>", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidGreaterThan(String value) {
            addCriterion("FARESOURCEID >", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidGreaterThanOrEqualTo(String value) {
            addCriterion("FARESOURCEID >=", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidLessThan(String value) {
            addCriterion("FARESOURCEID <", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidLessThanOrEqualTo(String value) {
            addCriterion("FARESOURCEID <=", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidLike(String value) {
            addCriterion("FARESOURCEID like", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidNotLike(String value) {
            addCriterion("FARESOURCEID not like", value, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidIn(List<String> values) {
            addCriterion("FARESOURCEID in", values, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidNotIn(List<String> values) {
            addCriterion("FARESOURCEID not in", values, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidBetween(String value1, String value2) {
            addCriterion("FARESOURCEID between", value1, value2, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFaresourceidNotBetween(String value1, String value2) {
            addCriterion("FARESOURCEID not between", value1, value2, "faresourceid");
            return (Criteria) this;
        }

        public Criteria andFareTpIsNull() {
            addCriterion("FARE_TP is null");
            return (Criteria) this;
        }

        public Criteria andFareTpIsNotNull() {
            addCriterion("FARE_TP is not null");
            return (Criteria) this;
        }

        public Criteria andFareTpEqualTo(String value) {
            addCriterion("FARE_TP =", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpNotEqualTo(String value) {
            addCriterion("FARE_TP <>", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpGreaterThan(String value) {
            addCriterion("FARE_TP >", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpGreaterThanOrEqualTo(String value) {
            addCriterion("FARE_TP >=", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpLessThan(String value) {
            addCriterion("FARE_TP <", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpLessThanOrEqualTo(String value) {
            addCriterion("FARE_TP <=", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpLike(String value) {
            addCriterion("FARE_TP like", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpNotLike(String value) {
            addCriterion("FARE_TP not like", value, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpIn(List<String> values) {
            addCriterion("FARE_TP in", values, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpNotIn(List<String> values) {
            addCriterion("FARE_TP not in", values, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpBetween(String value1, String value2) {
            addCriterion("FARE_TP between", value1, value2, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFareTpNotBetween(String value1, String value2) {
            addCriterion("FARE_TP not between", value1, value2, "fareTp");
            return (Criteria) this;
        }

        public Criteria andFlightNoIsNull() {
            addCriterion("FLIGHT_NO is null");
            return (Criteria) this;
        }

        public Criteria andFlightNoIsNotNull() {
            addCriterion("FLIGHT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andFlightNoEqualTo(String value) {
            addCriterion("FLIGHT_NO =", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoNotEqualTo(String value) {
            addCriterion("FLIGHT_NO <>", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoGreaterThan(String value) {
            addCriterion("FLIGHT_NO >", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoGreaterThanOrEqualTo(String value) {
            addCriterion("FLIGHT_NO >=", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoLessThan(String value) {
            addCriterion("FLIGHT_NO <", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoLessThanOrEqualTo(String value) {
            addCriterion("FLIGHT_NO <=", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoLike(String value) {
            addCriterion("FLIGHT_NO like", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoNotLike(String value) {
            addCriterion("FLIGHT_NO not like", value, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoIn(List<String> values) {
            addCriterion("FLIGHT_NO in", values, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoNotIn(List<String> values) {
            addCriterion("FLIGHT_NO not in", values, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoBetween(String value1, String value2) {
            addCriterion("FLIGHT_NO between", value1, value2, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightNoNotBetween(String value1, String value2) {
            addCriterion("FLIGHT_NO not between", value1, value2, "flightNo");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdIsNull() {
            addCriterion("FLIGHT_GROUP_ID is null");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdIsNotNull() {
            addCriterion("FLIGHT_GROUP_ID is not null");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdEqualTo(BigDecimal value) {
            addCriterion("FLIGHT_GROUP_ID =", value, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdNotEqualTo(BigDecimal value) {
            addCriterion("FLIGHT_GROUP_ID <>", value, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdGreaterThan(BigDecimal value) {
            addCriterion("FLIGHT_GROUP_ID >", value, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FLIGHT_GROUP_ID >=", value, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdLessThan(BigDecimal value) {
            addCriterion("FLIGHT_GROUP_ID <", value, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FLIGHT_GROUP_ID <=", value, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdIn(List<BigDecimal> values) {
            addCriterion("FLIGHT_GROUP_ID in", values, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdNotIn(List<BigDecimal> values) {
            addCriterion("FLIGHT_GROUP_ID not in", values, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FLIGHT_GROUP_ID between", value1, value2, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andFlightGroupIdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FLIGHT_GROUP_ID not between", value1, value2, "flightGroupId");
            return (Criteria) this;
        }

        public Criteria andRealflightIsNull() {
            addCriterion("REALFLIGHT is null");
            return (Criteria) this;
        }

        public Criteria andRealflightIsNotNull() {
            addCriterion("REALFLIGHT is not null");
            return (Criteria) this;
        }

        public Criteria andRealflightEqualTo(String value) {
            addCriterion("REALFLIGHT =", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightNotEqualTo(String value) {
            addCriterion("REALFLIGHT <>", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightGreaterThan(String value) {
            addCriterion("REALFLIGHT >", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightGreaterThanOrEqualTo(String value) {
            addCriterion("REALFLIGHT >=", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightLessThan(String value) {
            addCriterion("REALFLIGHT <", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightLessThanOrEqualTo(String value) {
            addCriterion("REALFLIGHT <=", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightLike(String value) {
            addCriterion("REALFLIGHT like", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightNotLike(String value) {
            addCriterion("REALFLIGHT not like", value, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightIn(List<String> values) {
            addCriterion("REALFLIGHT in", values, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightNotIn(List<String> values) {
            addCriterion("REALFLIGHT not in", values, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightBetween(String value1, String value2) {
            addCriterion("REALFLIGHT between", value1, value2, "realflight");
            return (Criteria) this;
        }

        public Criteria andRealflightNotBetween(String value1, String value2) {
            addCriterion("REALFLIGHT not between", value1, value2, "realflight");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxIsNull() {
            addCriterion("ADT_FUEL_TAX is null");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxIsNotNull() {
            addCriterion("ADT_FUEL_TAX is not null");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxEqualTo(BigDecimal value) {
            addCriterion("ADT_FUEL_TAX =", value, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxNotEqualTo(BigDecimal value) {
            addCriterion("ADT_FUEL_TAX <>", value, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxGreaterThan(BigDecimal value) {
            addCriterion("ADT_FUEL_TAX >", value, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ADT_FUEL_TAX >=", value, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxLessThan(BigDecimal value) {
            addCriterion("ADT_FUEL_TAX <", value, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ADT_FUEL_TAX <=", value, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxIn(List<BigDecimal> values) {
            addCriterion("ADT_FUEL_TAX in", values, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxNotIn(List<BigDecimal> values) {
            addCriterion("ADT_FUEL_TAX not in", values, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ADT_FUEL_TAX between", value1, value2, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtFuelTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ADT_FUEL_TAX not between", value1, value2, "adtFuelTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxIsNull() {
            addCriterion("ADT_AIRPORT_TAX is null");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxIsNotNull() {
            addCriterion("ADT_AIRPORT_TAX is not null");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxEqualTo(BigDecimal value) {
            addCriterion("ADT_AIRPORT_TAX =", value, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxNotEqualTo(BigDecimal value) {
            addCriterion("ADT_AIRPORT_TAX <>", value, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxGreaterThan(BigDecimal value) {
            addCriterion("ADT_AIRPORT_TAX >", value, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ADT_AIRPORT_TAX >=", value, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxLessThan(BigDecimal value) {
            addCriterion("ADT_AIRPORT_TAX <", value, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ADT_AIRPORT_TAX <=", value, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxIn(List<BigDecimal> values) {
            addCriterion("ADT_AIRPORT_TAX in", values, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxNotIn(List<BigDecimal> values) {
            addCriterion("ADT_AIRPORT_TAX not in", values, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ADT_AIRPORT_TAX between", value1, value2, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andAdtAirportTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ADT_AIRPORT_TAX not between", value1, value2, "adtAirportTax");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdIsNull() {
            addCriterion("JINKUN_SEG_ID is null");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdIsNotNull() {
            addCriterion("JINKUN_SEG_ID is not null");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdEqualTo(String value) {
            addCriterion("JINKUN_SEG_ID =", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdNotEqualTo(String value) {
            addCriterion("JINKUN_SEG_ID <>", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdGreaterThan(String value) {
            addCriterion("JINKUN_SEG_ID >", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdGreaterThanOrEqualTo(String value) {
            addCriterion("JINKUN_SEG_ID >=", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdLessThan(String value) {
            addCriterion("JINKUN_SEG_ID <", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdLessThanOrEqualTo(String value) {
            addCriterion("JINKUN_SEG_ID <=", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdLike(String value) {
            addCriterion("JINKUN_SEG_ID like", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdNotLike(String value) {
            addCriterion("JINKUN_SEG_ID not like", value, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdIn(List<String> values) {
            addCriterion("JINKUN_SEG_ID in", values, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdNotIn(List<String> values) {
            addCriterion("JINKUN_SEG_ID not in", values, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdBetween(String value1, String value2) {
            addCriterion("JINKUN_SEG_ID between", value1, value2, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andJinkunSegIdNotBetween(String value1, String value2) {
            addCriterion("JINKUN_SEG_ID not between", value1, value2, "jinkunSegId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdIsNull() {
            addCriterion("FLIGHT_PLAN_ID is null");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdIsNotNull() {
            addCriterion("FLIGHT_PLAN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdEqualTo(String value) {
            addCriterion("FLIGHT_PLAN_ID =", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdNotEqualTo(String value) {
            addCriterion("FLIGHT_PLAN_ID <>", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdGreaterThan(String value) {
            addCriterion("FLIGHT_PLAN_ID >", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdGreaterThanOrEqualTo(String value) {
            addCriterion("FLIGHT_PLAN_ID >=", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdLessThan(String value) {
            addCriterion("FLIGHT_PLAN_ID <", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdLessThanOrEqualTo(String value) {
            addCriterion("FLIGHT_PLAN_ID <=", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdLike(String value) {
            addCriterion("FLIGHT_PLAN_ID like", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdNotLike(String value) {
            addCriterion("FLIGHT_PLAN_ID not like", value, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdIn(List<String> values) {
            addCriterion("FLIGHT_PLAN_ID in", values, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdNotIn(List<String> values) {
            addCriterion("FLIGHT_PLAN_ID not in", values, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdBetween(String value1, String value2) {
            addCriterion("FLIGHT_PLAN_ID between", value1, value2, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andFlightPlanIdNotBetween(String value1, String value2) {
            addCriterion("FLIGHT_PLAN_ID not between", value1, value2, "flightPlanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdIsNull() {
            addCriterion("JINKUN_LAN_ID is null");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdIsNotNull() {
            addCriterion("JINKUN_LAN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdEqualTo(String value) {
            addCriterion("JINKUN_LAN_ID =", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdNotEqualTo(String value) {
            addCriterion("JINKUN_LAN_ID <>", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdGreaterThan(String value) {
            addCriterion("JINKUN_LAN_ID >", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdGreaterThanOrEqualTo(String value) {
            addCriterion("JINKUN_LAN_ID >=", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdLessThan(String value) {
            addCriterion("JINKUN_LAN_ID <", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdLessThanOrEqualTo(String value) {
            addCriterion("JINKUN_LAN_ID <=", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdLike(String value) {
            addCriterion("JINKUN_LAN_ID like", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdNotLike(String value) {
            addCriterion("JINKUN_LAN_ID not like", value, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdIn(List<String> values) {
            addCriterion("JINKUN_LAN_ID in", values, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdNotIn(List<String> values) {
            addCriterion("JINKUN_LAN_ID not in", values, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdBetween(String value1, String value2) {
            addCriterion("JINKUN_LAN_ID between", value1, value2, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andJinkunLanIdNotBetween(String value1, String value2) {
            addCriterion("JINKUN_LAN_ID not between", value1, value2, "jinkunLanId");
            return (Criteria) this;
        }

        public Criteria andAssembledTpIsNull() {
            addCriterion("ASSEMBLED_TP is null");
            return (Criteria) this;
        }

        public Criteria andAssembledTpIsNotNull() {
            addCriterion("ASSEMBLED_TP is not null");
            return (Criteria) this;
        }

        public Criteria andAssembledTpEqualTo(Object value) {
            addCriterion("ASSEMBLED_TP =", value, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpNotEqualTo(Object value) {
            addCriterion("ASSEMBLED_TP <>", value, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpGreaterThan(Object value) {
            addCriterion("ASSEMBLED_TP >", value, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpGreaterThanOrEqualTo(Object value) {
            addCriterion("ASSEMBLED_TP >=", value, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpLessThan(Object value) {
            addCriterion("ASSEMBLED_TP <", value, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpLessThanOrEqualTo(Object value) {
            addCriterion("ASSEMBLED_TP <=", value, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpIn(List<Object> values) {
            addCriterion("ASSEMBLED_TP in", values, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpNotIn(List<Object> values) {
            addCriterion("ASSEMBLED_TP not in", values, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpBetween(Object value1, Object value2) {
            addCriterion("ASSEMBLED_TP between", value1, value2, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andAssembledTpNotBetween(Object value1, Object value2) {
            addCriterion("ASSEMBLED_TP not between", value1, value2, "assembledTp");
            return (Criteria) this;
        }

        public Criteria andSegCabinIsNull() {
            addCriterion("SEG_CABIN is null");
            return (Criteria) this;
        }

        public Criteria andSegCabinIsNotNull() {
            addCriterion("SEG_CABIN is not null");
            return (Criteria) this;
        }

        public Criteria andSegCabinEqualTo(String value) {
            addCriterion("SEG_CABIN =", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinNotEqualTo(String value) {
            addCriterion("SEG_CABIN <>", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinGreaterThan(String value) {
            addCriterion("SEG_CABIN >", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinGreaterThanOrEqualTo(String value) {
            addCriterion("SEG_CABIN >=", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinLessThan(String value) {
            addCriterion("SEG_CABIN <", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinLessThanOrEqualTo(String value) {
            addCriterion("SEG_CABIN <=", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinLike(String value) {
            addCriterion("SEG_CABIN like", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinNotLike(String value) {
            addCriterion("SEG_CABIN not like", value, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinIn(List<String> values) {
            addCriterion("SEG_CABIN in", values, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinNotIn(List<String> values) {
            addCriterion("SEG_CABIN not in", values, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinBetween(String value1, String value2) {
            addCriterion("SEG_CABIN between", value1, value2, "segCabin");
            return (Criteria) this;
        }

        public Criteria andSegCabinNotBetween(String value1, String value2) {
            addCriterion("SEG_CABIN not between", value1, value2, "segCabin");
            return (Criteria) this;
        }

        public Criteria andTravelTypeIsNull() {
            addCriterion("TRAVEL_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTravelTypeIsNotNull() {
            addCriterion("TRAVEL_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTravelTypeEqualTo(String value) {
            addCriterion("TRAVEL_TYPE =", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeNotEqualTo(String value) {
            addCriterion("TRAVEL_TYPE <>", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeGreaterThan(String value) {
            addCriterion("TRAVEL_TYPE >", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeGreaterThanOrEqualTo(String value) {
            addCriterion("TRAVEL_TYPE >=", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeLessThan(String value) {
            addCriterion("TRAVEL_TYPE <", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeLessThanOrEqualTo(String value) {
            addCriterion("TRAVEL_TYPE <=", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeLike(String value) {
            addCriterion("TRAVEL_TYPE like", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeNotLike(String value) {
            addCriterion("TRAVEL_TYPE not like", value, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeIn(List<String> values) {
            addCriterion("TRAVEL_TYPE in", values, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeNotIn(List<String> values) {
            addCriterion("TRAVEL_TYPE not in", values, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeBetween(String value1, String value2) {
            addCriterion("TRAVEL_TYPE between", value1, value2, "travelType");
            return (Criteria) this;
        }

        public Criteria andTravelTypeNotBetween(String value1, String value2) {
            addCriterion("TRAVEL_TYPE not between", value1, value2, "travelType");
            return (Criteria) this;
        }

        public Criteria andDepTermIsNull() {
            addCriterion("DEP_TERM is null");
            return (Criteria) this;
        }

        public Criteria andDepTermIsNotNull() {
            addCriterion("DEP_TERM is not null");
            return (Criteria) this;
        }

        public Criteria andDepTermEqualTo(String value) {
            addCriterion("DEP_TERM =", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermNotEqualTo(String value) {
            addCriterion("DEP_TERM <>", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermGreaterThan(String value) {
            addCriterion("DEP_TERM >", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermGreaterThanOrEqualTo(String value) {
            addCriterion("DEP_TERM >=", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermLessThan(String value) {
            addCriterion("DEP_TERM <", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermLessThanOrEqualTo(String value) {
            addCriterion("DEP_TERM <=", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermLike(String value) {
            addCriterion("DEP_TERM like", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermNotLike(String value) {
            addCriterion("DEP_TERM not like", value, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermIn(List<String> values) {
            addCriterion("DEP_TERM in", values, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermNotIn(List<String> values) {
            addCriterion("DEP_TERM not in", values, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermBetween(String value1, String value2) {
            addCriterion("DEP_TERM between", value1, value2, "depTerm");
            return (Criteria) this;
        }

        public Criteria andDepTermNotBetween(String value1, String value2) {
            addCriterion("DEP_TERM not between", value1, value2, "depTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermIsNull() {
            addCriterion("ARRI_TERM is null");
            return (Criteria) this;
        }

        public Criteria andArriTermIsNotNull() {
            addCriterion("ARRI_TERM is not null");
            return (Criteria) this;
        }

        public Criteria andArriTermEqualTo(String value) {
            addCriterion("ARRI_TERM =", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermNotEqualTo(String value) {
            addCriterion("ARRI_TERM <>", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermGreaterThan(String value) {
            addCriterion("ARRI_TERM >", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermGreaterThanOrEqualTo(String value) {
            addCriterion("ARRI_TERM >=", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermLessThan(String value) {
            addCriterion("ARRI_TERM <", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermLessThanOrEqualTo(String value) {
            addCriterion("ARRI_TERM <=", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermLike(String value) {
            addCriterion("ARRI_TERM like", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermNotLike(String value) {
            addCriterion("ARRI_TERM not like", value, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermIn(List<String> values) {
            addCriterion("ARRI_TERM in", values, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermNotIn(List<String> values) {
            addCriterion("ARRI_TERM not in", values, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermBetween(String value1, String value2) {
            addCriterion("ARRI_TERM between", value1, value2, "arriTerm");
            return (Criteria) this;
        }

        public Criteria andArriTermNotBetween(String value1, String value2) {
            addCriterion("ARRI_TERM not between", value1, value2, "arriTerm");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}